DataPipe

USD 590 USD 399 Buy Now! Download DataPipe Evaluation (1 Mb) Demonstration - Using DataPipe to perform in-database rectification

Why waste hours manually fixing data? DataPipe fixes data problems with the data still in your database. You can perform complex search and replaces, cleanse and fix awkward text processing issues, all without programming. With DataPipe you can achieve in seconds what would take hours with other database tools or programming languages. Start taking control of your data NOW! Every database contains some degree of invalid or incorrect data, usually because of operator error or programming errors. These errors can prevent normal processing of the data, can cause searches for the records to fail, and invalid data formatting can cause mail-merges of the data to look very unprofessional. DataPipe includes TextPipe Pro and applies its amazing text processing capabilities to data in your database. TextPipe provides a huge range of filters for manipulating text. DataPipe's unmatched power comes from TextPipe's unique architecture and combining and arranging it's filters to suit each task. See Demo
Process Data From Anywhere DataPipe connects to any industry standard OLE DB/ODBC database using database drivers provided by the database vendors. Choose the database and table or query that contains the data you need to modify (Click to enlarge). Please see TextPipe if you need to extract data or process text files only, ResumePipe if you need to cleanse and process emails, or WordPipe if you need to search and replace in many MS Word documents, or ExcelPipe for Excel spreadsheets. Lightning Fast Search and Replace DataPipe offers the fastest and most powerful search and replaces: Exact search (including multi-line and binary character search) Pattern or wildcard search 'Sounds-like' search Fuzzy search (great for finding typing errors) Click here for more details The replacement text can include all or part of the original text or a re-arrangement of it, and the case of the replacement text can be automatically altered to preserve the case of the original text. The replacement text can also be modified by any combination of filters such as by converting it to Upper Case, performing further search and replaces inside the replacement text or even a database or dictionary lookup. Replace text interactively in preview mode and in live database mode (Click to enlarge). Manipulate Precise Sections of Text DataPipe can manipulate specific portions of the text rather than the entire text, such as Line Ranges, Column Ranges, Lines Matching a Pattern and Lines Not Matching a Pattern. You can combine sections together, for example, to alter a specific line and column range. You can also apply further text manipulations to the Replaced Text in a Search and Replace operation, such as by making the Replacement Text UPPERCASE.		Enterprise Features DataPipe's enterprise features include: No limit on manipulations in a single pass - so if you have 8 million records, you only need to change them once No limit on the number of records processed Detailed audit logs to track job start and end times and unsuccessful updates Restart control logic to resume aborted jobs Precise control over cursor and locking options to optimize speed with your database. CRM Integration DataPipe makes it easy to connect to Customer Relationship Management (CRM) tools like GoldMine, Onyx, Siebel, Great Elk, ACT!, Eipiphany and more.   User Benefits Check out the powerful functions listed below: Fast! Interactive search and replace - check records before you change them Process multiple tables in multiple databases Correct capitalization in names and surnames (even with names like Mac and Mc, de and van de etc) Swap data fields around, such as date fields MM/DD/YYYY -> DD/MM/YYYY, swap surnames and first names etc Standardize formatting of addresses (e.g. PO Box, P.O. Box, POBOX) Standardize phone number formatting (e.g. 800 612 0382, (800) 612-0382) Extract email addresses for your next marketing campaign Trim blanks and multiple white space Remove binary "garbage" characters Remove HTML and XML Insert or remove text within a field No need for custom programming in 99% of cases. If you need to, you can write custom code using industry-standard VBScript or JScript Easy to use with integrated online help and tips Automate DataPipe to run at predetermined times using an external scheduling tool Translations are available for other languages Click here to see more   Some of Our Clients DataPipe is used by Aspect Computing, IMS, UC Davis Medical Center, City of Winnipeg, Trucking2Go, Harrington Industrial Plastics, Trane, United Nations, Intelli-Source, Suramericana de Seguros SA, Johnson & Johnson, East Tennessee Computers, Saskatchewan Learning and many other large organisations. Single User, per CPU and Site Licenses DataPipe comes in both Single User, per CPU and Site licenses: Windows 95, 98, ME, NT, 2000 and XP Hard Disk with 15 MB free disk space 64 MB RAM SQL Server, Access, Informix, Sybase, DB2, Oracle, MySQL, DBF, FoxPro, FileMaker Pro, Excel Spreadsheets or any OLE DB/ODBC compliant database. Multi-user, Site and Enterprise licenses are also available to enhance the efficiency of your entire team.

The DataPipe Difference

DataPipe is not a traditional data manipulation application: DataPipe is the only database application where you can interactively search and replace through records in your database DataPipe's pattern matching AND replacing allows you to rearrange the text in a field e.g. swapping surnames and first names And DataPipe provides all this without the need for custom programming, however, ... ...If you need to perform custom processing, DataPipe allows you to write your own filters in industry standard VBScript, JScript or a variety of other scripting languages.

If you have trouble setting up transformations yourself, why not pay one of our data transformation consultants to do it for you?

Editor’s pick from http://www.SoftwareSeeker.com, their highest award (Jan 2003)

Try DataPipe today!

USD 590 USD 399 Buy Now!   Download DataPipe Evaluation (1 Mb)